package com.example.kai.uno;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class MyDBHelper extends SQLiteOpenHelper {

    public static final String CREATE_USERDATA="create table userData(" +
            "id integer primary key autoincrement,"
            +"name text,"
            +"password text)";

    public static final String CREATE_SCOREDATA="create table scoreData(" +
            "id integer primary key autoincrement,"
            +"_id text,"
            +"score integer,"
            +"time text) ";
    public static final String CREATE_SCOREDATA1="create table scoreData1(" +
            "id integer primary key autoincrement,"
            +"_id text,"
            +"score integer,"
            +"time text) ";
    public static final String CREATE_SCOREDATA2="create table scoreData2(" +
            "id integer primary key autoincrement,"
            +"_id text,"
            +"score integer,"
            +"time text) ";
    public static final String CREATE_SCOREDATA3="create table scoreData3(" +
            "id integer primary key autoincrement,"
            +"_id text,"
            +"score integer,"
            +"time text) ";


    private Context mContext;

    public MyDBHelper(Context context, String name, SQLiteDatabase.CursorFactory cursorFactory, int version){
        super(context,name,cursorFactory,version);
        mContext=context;
    }

    public  void onCreate(SQLiteDatabase db){
        db.execSQL(CREATE_USERDATA);
        db.execSQL(CREATE_SCOREDATA);
        db.execSQL(CREATE_SCOREDATA1);
        db.execSQL(CREATE_SCOREDATA2);
        db.execSQL(CREATE_SCOREDATA3);

    }

    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){

    }
}


